If you attempt to publish behaviors in the SAS^® Activity-Based Management client (File ► Publish ► Behaviors) you might receive the following or similar error in the Publish Behaviors Data Summary:

   ModelName Publish Behaviors Data Summary

   Fatal Errors
   Total Number of Fatal Error: 1
   Description: Insertion of records in the Behavior Table failed for the Behavior Table with the
   name[behavior] under Library [behbeg] in the Meta Data Server:[abmsrv1.trc.sas.com].
   (NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) 9.1
   (TS1M3) Licensed to Employee SID, Site 0055438001. NOTE: This session is executing on
   the XP_PRO platform. NOTE: SAS 9.1.3 Service Pack 4NOTE: SAS Initialization used
   (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Libref TEST
   was successfully assigned as follows:Engine: META Physical Name: 1 option nosource;
   LIBNAME TEST META METAOUT=DATA REPID=A0000001.A5WQZK4S LIBID=B10005EH1
   ipaddr="l16648" Port=8561 protocol=bridge;proc sql noprint;1 ! proc sql noprint;1 ! insert into
   TEST.behavior(Id,Name,UnitValue, TotalValue,Period) values ('Fixed x Loc x Worker's
   Compensat','Fixed x Loc x Worker's ______________________ ___
   ______________________ ___ ___________ ___________ ___ 49 49 49 49 49 4915
    ! Compensation_2054',0.00043133720818765, NULL,'2009_Q1_ACTUAL')
   NOTE 49-169: The meaning of an identifier after a quoted string may change in a future
   SAS release. Inserting white space between a quoted string and the succeeding
   identifier is recommended.
   ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric
   constant, a datetime constant, a missing value, ), +, ',', -, MISSING, NULL, USER.
   ERROR 76-322: Syntax error, statement will be ignored.
   NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements
   NOTE: The SAS System stopped processing this step because of errors.
   NOTE: PROCEDURE SQL used (Total process time): real time 0.06 seconds cpu time
   0.00 seconds )

   Errors
   Total Number of Errors: 0

   Warnings
   Total Number of Warnings: 0

This error can be caused by tagging an account as a behavior where the account's dimension signature includes a dimension member name with an apostrophe or other special character.

To circumvent the error, remove the apostrophe and/or other special characters from the dimension member name.

Operating System and Release Information